HSStudentLeaseHistory 
Logical Entity Name  HSStudentLeaseHistory 
Default Table Name  HSStudentLeaseHistory 
Physical Only  NO 
Definition 
 
Note 
 

HSStudentLeaseHistory Columns 
ColumnName  Domain  Datatype  NULL  Definition 
HSStudentLeaseHistoryID(PK)    int  NO 
 
StartDate    datetime  NO 
 
MoveOutDate    datetime  YES 
 
EndDate    datetime  NO 
 
ActualEndDate    datetime  YES 
 
AdTermID(FK)    int  YES 
 
HSLeaseStatusID(FK)    int  NO 
 
SyStudentID(FK)    int  NO 
 
HSBuildingRoomsID(FK)    int  NO 
 
HSStudentApplicationID(FK)    int  NO 
 
HSMoveOutReasonID(FK)    int  YES 
 
LeaseAmount    money  NO 
 
Frequency    char(1)  NO 
 
TerminationFee    money  YES 
 
SaBillCodeID(FK)    int  YES 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
LastPrintDate    datetime  YES 
 
AdEnrollID(FK)    int  YES 
 
FaStudentAYID(FK)    int  YES 
 
Reason    varchar(max)  YES 
 
DateSelectedOn    char(1)  YES 
 
IsAcademicYearLease    bit  NO 
 
SaTransCodeID(FK)    int  YES 
 
SaBillTermID(FK)    int  YES 
 
ManuallyUpdateDates    bit  NO 
 
LastFrequency    char(1)  YES 
 
RoomSwitchDate    datetime  YES 
 
StartDateOnRoomSwitch    datetime  YES 
 
TerminationFeeSubsidiaryID    char(10)  YES 
 

HSStudentLeaseHistory Primary and Unique Keys 
Key Name  Key Type  Keys 
HSStudentLeaseHistory_HSStudentLeaseHistoryID_U_C_IDX  PrimaryKey  HSStudentLeaseHistoryID 

HSStudentLeaseHistory Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdTerm  Non-Identifying  Zero or One to Zero or More  FK_HSStudentLeaseHistory_AdTermID_AdTerm_AdTermID      AdTermID  NO  YES 
HsBuildingRooms  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_HSBuildingRoomsID_HsBuildingRooms_HsBuildingRoomsID      HSBuildingRoomsID  NO  YES 
HSLeaseStatus  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_HSLeaseStatusID_HSLeaseStatus_HSLeaseStatusID      HSLeaseStatusID  NO  YES 
HSMoveOutReason  Non-Identifying  Zero or One to Zero or More  FK_HSStudentLeaseHistory_HSMoveOutReasonID_HSMoveOutReason_HSMoveOutReasonID      HSMoveOutReasonID  NO  YES 
HsStudentApplication  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_HSStudentApplicationID_HsStudentApplication_HsStudentApplicationID      HSStudentApplicationID  NO  YES 
SaBillCode  Non-Identifying  Zero or One to Zero or More  FK_HSStudentLeaseHistory_SaBillCodeID_SaBillCode_SaBillCodeID      SaBillCodeID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_SyStudentID_SyStudent_SyStudentID      SyStudentID  NO  YES 
AdEnroll  Non-Identifying  Zero or One to Zero or More  FK_HsStudentLeaseHistoryAdEnrollID_AdEnrollAdEnrollID      AdEnrollID  NO  YES 
FaStudentAY  Non-Identifying  Zero or One to Zero or More  FK_HsStudentLeaseHistoryFaStudentAYID_FaStudentAYFaStudentAYID      FaStudentAYID  NO  YES 
AdTerm  Non-Identifying  Zero or One to Zero or More  FK_HsStudentLeaseHistorySaBillTermID_AdTermAdTermID      SaBillTermID  NO  YES 
SaBillCode  Non-Identifying  Zero or One to Zero or More  FK_HsStudentLeaseHistorySaTransCodeID_SaBillCodeSaBillCodeID      SaTransCodeID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
HsBuildingRoomsStudents  Non-Identifying  One To Zero or More  FK_HsBuildingRoomsStudents_HsStudentLeaseHistoryID_HsStudentLeaseHistory_HsStudentLeaseHistoryID        NO  YES 
HSStudentLeaseChargeSchedule  Non-Identifying  One To Zero or More  FK_HSStudentLeaseChargeSchedule_HSStudentLeaseHistoryID_HSStudentLeaseHistory_HSStudentLeaseHistoryID        NO  YES 
HSStudentLeaseDocument  Non-Identifying  One To Zero or More  FK_HSStudentLeaseDocument_HSStudentLeaseHistoryID_HSStudentLeaseHistory_HSStudentLeaseHistoryID        NO  YES 
HSStudentLeaseEvent  Non-Identifying  One To Zero or More  FK_HSStudentLeaseEvent_HSStudentLeaseHistoryID_HSStudentLeaseHistory_HSStudentLeaseHistoryID        NO  YES 

HSStudentLeaseHistory Check Constraints 
Check Constraint Name  CheckConstraint